<?php if(!defined('PATH_HD'))exit;
$db->exe("DROP TABLE IF EXISTS `hd_category`");
$db->exe("CREATE TABLE `hd_category` (
  `catid` smallint(6) NOT NULL AUTO_INCREMENT COMMENT '栏目ID',
  `pid` smallint(6) NOT NULL COMMENT '父ID',
  `cname` varchar(100) NOT NULL COMMENT '栏目名称',
  `htmldir` varchar(45) NOT NULL COMMENT '栏目静态文件目录(必须为英文)',
  `gourl` varchar(200) NOT NULL COMMENT '跳转url',
  `listhtml` varchar(200) NOT NULL COMMENT '栏目页生成url规则',
  `archtml` varchar(45) NOT NULL COMMENT '内容页生成url规则',
  `listtpl` varchar(45) NOT NULL COMMENT '列表页模板',
  `arctpl` varchar(45) NOT NULL COMMENT '内容模板',
  `islisthtml` tinyint(1) NOT NULL DEFAULT '1' COMMENT '栏目是否生成html',
  `isarchtml` tinyint(1) NOT NULL COMMENT '内容页是否生成html',
  `keywords` varchar(100) NOT NULL COMMENT '栏目关键字',
  `descroption` varchar(250) NOT NULL COMMENT '栏目描述',
  `sort` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT ' 栏目排序',
  PRIMARY KEY (`catid`)
) ENGINE=MyISAM AUTO_INCREMENT=118 DEFAULT CHARSET=utf8 COMMENT='栏目表\n'");
$db->exe('REPLACE INTO `hd_category`(`catid`,`pid`,`cname`,`htmldir`,`gourl`,`listhtml`,`archtml`,`listtpl`,`arctpl`,`islisthtml`,`isarchtml`,`keywords`,`descroption`,`sort`)VALUES ("109","0","程序","program","","{htmldir}/{y}{m}{d}/{catid}_{page}.html","{htmldir}/{y}{m}{d}/{nid}.html","list.html","arc.html","1","1","程序","程序语言","0")');
$db->exe('REPLACE INTO `hd_category`(`catid`,`pid`,`cname`,`htmldir`,`gourl`,`listhtml`,`archtml`,`listtpl`,`arctpl`,`islisthtml`,`isarchtml`,`keywords`,`descroption`,`sort`)VALUES ("110","109","PHP","php","","{htmldir}/{y}{m}{d}/{catid}_{page}.html","{htmldir}/{y}{m}{d}/{nid}.html","list.html","arc.html","1","1","","","0")');
$db->exe('REPLACE INTO `hd_category`(`catid`,`pid`,`cname`,`htmldir`,`gourl`,`listhtml`,`archtml`,`listtpl`,`arctpl`,`islisthtml`,`isarchtml`,`keywords`,`descroption`,`sort`)VALUES ("111","110","smarty","","","{htmldir}/{y}{m}{d}/{catid}_{page}.html","{htmldir}/{y}{m}{d}/{nid}.html","list.html","arc.html","1","1","","","0")');

?>